---
title: "SQL-015 to SQL-039: Insert (create) operations"
summary: Create operations across this library — stored-procedure inserts and inline INSERT statements.
status: draft
owner: SAIF Documentation Generator
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# SQL-015 to SQL-039: Insert (create) operations

This page documents all 25 Create-type SQL operations (SQL-015 through SQL-039). Stored-procedure inserts have their body retrieval marked unavailable for this run (Legends CLI offline); see [Procedures](../procedures/index.md).

## SQL-015 clsAppeal

`clsAppeal` — StoredProc operation against `pk80001_legalnet.insertAppeal`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-015 |
| **Operation type** | StoredProc |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAppeal` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.insertAppeal(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsAppeal.vb`

---
## SQL-016 clsAppealExtension

`clsAppealExtension` — StoredProc operation against `pk80001_legalnet.insertAppealExtension`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-016 |
| **Operation type** | StoredProc |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAppealExtension` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.insertAppealExtension(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsAppealExtension.vb`

---
## SQL-017 clsAttorneyConflict.Criteria.InsertSQL

`clsAttorneyConflict.Criteria.InsertSQL` — Insert operation against `ATTORNEY_CONFLICT`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-017 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneyConflict` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_CONFLICT](../database-tables.md#attorney_conflict) | INSERT | See Sample SQL below |

### Sample SQL

```sql
-- Insert against ATTORNEY_CONFLICT
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Insert statements against ATTORNEY_CONFLICT in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb`

---
## SQL-018 clsAttorneyPolicyAssignment.Criteria.InsertSQL

`clsAttorneyPolicyAssignment.Criteria.InsertSQL` — Insert operation against `ATTORNEY_POLICY_ASSIGNMENT`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-018 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneyPolicyAssignment` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_POLICY_ASSIGNMENT](../database-tables.md#attorney_policy_assignment) | INSERT | See Sample SQL below |

### Sample SQL

```sql
-- Insert against ATTORNEY_POLICY_ASSIGNMENT
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Insert statements against ATTORNEY_POLICY_ASSIGNMENT in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyPolicyAssignment.vb`

---
## SQL-019 clsAttorneyProfile

`clsAttorneyProfile` — StoredProc operation against `pk80001_legalnet.insertAttyProfile`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-019 |
| **Operation type** | StoredProc |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAttorneyProfile` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.insertAttyProfile(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyProfile.vb`

---
## SQL-020 clsAttorneySchedule.Criteria.InsertSQL

`clsAttorneySchedule.Criteria.InsertSQL` — Insert operation against `ATTORNEY_SCHEDULE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-020 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneySchedule` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_SCHEDULE](../database-tables.md#attorney_schedule) | INSERT | See Sample SQL below |

### Sample SQL

```sql
-- Insert against ATTORNEY_SCHEDULE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Insert statements against ATTORNEY_SCHEDULE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneySchedule.vb`

---
## SQL-021 clsAttorneyWorkerAssignment.Criteria.InsertSQL

`clsAttorneyWorkerAssignment.Criteria.InsertSQL` — Insert operation against `ATTORNEY_WORKER_ASSIGNMENT`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-021 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneyWorkerAssignment` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_WORKER_ASSIGNMENT](../database-tables.md#attorney_worker_assignment) | INSERT | See Sample SQL below |

### Sample SQL

```sql
-- Insert against ATTORNEY_WORKER_ASSIGNMENT
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Insert statements against ATTORNEY_WORKER_ASSIGNMENT in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyWorkerAssignment.vb`

---
## SQL-022 clsCaseCost.Criteria.InsertSQL

`clsCaseCost.Criteria.InsertSQL` — Insert operation against `CASE_COST`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-022 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsCaseCost` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [CASE_COST](../database-tables.md#case_cost) | INSERT | See Sample SQL below |

### Sample SQL

```sql
-- Insert against CASE_COST
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Insert statements against CASE_COST in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseCost.vb`

---
## SQL-023 clsCaseNote

`clsCaseNote` — StoredProc operation against `pk80001_legalnet.case_note_insert`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-023 |
| **Operation type** | StoredProc |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsCaseNote` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.case_note_insert(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseNote.vb`

---
## SQL-024 clsCaseOutcome

`clsCaseOutcome` — StoredProc operation against `pk80001_legalnet.InsertCaseOutcome`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-024 |
| **Operation type** | StoredProc |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsCaseOutcome` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.InsertCaseOutcome(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseOutcome.vb`

---
## SQL-025 clsCaseStatusHistory.Criteria.InsertSQL

`clsCaseStatusHistory.Criteria.InsertSQL` — Insert operation against `CASE_STATUS_HISTORY`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-025 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsCaseStatusHistory` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [CASE_STATUS_HISTORY](../database-tables.md#case_status_history) | INSERT | See Sample SQL below |

### Sample SQL

```sql
-- Insert against CASE_STATUS_HISTORY
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Insert statements against CASE_STATUS_HISTORY in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseStatusHistory.vb`

---
## SQL-026 clsHearingLocation.Criteria.InsertSQL

`clsHearingLocation.Criteria.InsertSQL` — Insert operation against `HEARING_LOCATION`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-026 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsHearingLocation` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [HEARING_LOCATION](../database-tables.md#hearing_location) | INSERT | See Sample SQL below |

### Sample SQL

```sql
-- Insert against HEARING_LOCATION
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Insert statements against HEARING_LOCATION in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsHearingLocation.vb`

---
## SQL-027 clsHearingLocationInfo.Criteria.InsertSQL

`clsHearingLocationInfo.Criteria.InsertSQL` — Insert operation against `HEARING_LOCATION`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-027 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsHearingLocationInfo` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [HEARING_LOCATION](../database-tables.md#hearing_location) | INSERT | See Sample SQL below |

### Sample SQL

```sql
-- Insert against HEARING_LOCATION
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Insert statements against HEARING_LOCATION in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsHearingLocationInfo.vb`

---
## SQL-028 clsLegalCase

`clsLegalCase` — StoredProc operation against `pk80001_legalnet.InsertLegalCase`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-028 |
| **Operation type** | StoredProc |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLegalCase` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.InsertLegalCase(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCase.vb`

---
## SQL-029 clsLegalCaseEvaluation

`clsLegalCaseEvaluation` — StoredProc operation against `pk80001_legalnet.InsertLCE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-029 |
| **Operation type** | StoredProc |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLegalCaseEvaluation` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.InsertLCE(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEvaluation.vb`

---
## SQL-030 clsLegalFileLocation

`clsLegalFileLocation` — StoredProc operation against `pk80001_legalnet.insertFileLocation`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-030 |
| **Operation type** | StoredProc |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLegalFileLocation` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.insertFileLocation(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalFileLocation.vb`

---
## SQL-031 clsLegalPerson.Criteria.InsertSQL

`clsLegalPerson.Criteria.InsertSQL` — Insert operation against `LEGAL_PERSON`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-031 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsLegalPerson` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_PERSON](../database-tables.md#legal_person) | INSERT | See Sample SQL below |

### Sample SQL

```sql
-- Insert against LEGAL_PERSON
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Insert statements against LEGAL_PERSON in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPerson.vb`

---
## SQL-032 clsLegalPersonType.Criteria.InsertSQL

`clsLegalPersonType.Criteria.InsertSQL` — Insert operation against `LEGAL_PERSON_TYPE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-032 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsLegalPersonType` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_PERSON_TYPE](../database-tables.md#legal_person_type) | INSERT | See Sample SQL below |

### Sample SQL

```sql
-- Insert against LEGAL_PERSON_TYPE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Insert statements against LEGAL_PERSON_TYPE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPersonType.vb`

---
## SQL-033 clsLegalSchedule

`clsLegalSchedule` — StoredProc operation against `pk80001_legalnet.insertSchedule`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-033 |
| **Operation type** | StoredProc |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLegalSchedule` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.insertSchedule(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalSchedule.vb`

---
## SQL-034 clsOtherFirm.Criteria.InsertSQL

`clsOtherFirm.Criteria.InsertSQL` — Insert operation against `OTHER_FIRM`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-034 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOtherFirm` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OTHER_FIRM](../database-tables.md#other_firm) | INSERT | See Sample SQL below |

### Sample SQL

```sql
-- Insert against OTHER_FIRM
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Insert statements against OTHER_FIRM in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsOtherFirm.vb`

---
## SQL-035 clsOtherLegalParty.Criteria.InsertSQL

`clsOtherLegalParty.Criteria.InsertSQL` — Insert operation against `LEGAL_CASE_EMPLOYER`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-035 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOtherLegalParty` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_CASE_EMPLOYER](../database-tables.md#legal_case_employer) | INSERT | See Sample SQL below |

### Sample SQL

```sql
-- Insert against LEGAL_CASE_EMPLOYER
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Insert statements against LEGAL_CASE_EMPLOYER in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsOtherLegalParty.vb`

---
## SQL-036 clsOutcomeIssue.Criteria.InsertSQL

`clsOutcomeIssue.Criteria.InsertSQL` — Insert operation against `OUTCOME_ISSUE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-036 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOutcomeIssue` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OUTCOME_ISSUE](../database-tables.md#outcome_issue) | INSERT | See Sample SQL below |

### Sample SQL

```sql
-- Insert against OUTCOME_ISSUE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Insert statements against OUTCOME_ISSUE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsOutcomeIssue.vb`

---
## SQL-037 clsOutcomeStaff.Criteria.InsertSQL

`clsOutcomeStaff.Criteria.InsertSQL` — Insert operation against `OUTCOME_STAFF`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-037 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOutcomeStaff` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OUTCOME_STAFF](../database-tables.md#outcome_staff) | INSERT | See Sample SQL below |

### Sample SQL

```sql
-- Insert against OUTCOME_STAFF
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Insert statements against OUTCOME_STAFF in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsOutcomeStaff.vb`

---
## SQL-038 clsOutOFTownRotationAssgn.Criteria.InsertSQL

`clsOutOFTownRotationAssgn.Criteria.InsertSQL` — Insert operation against `OUT_OF_TOWN_ROTATION_ASSGN`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-038 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOutOFTownRotationAssgn` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OUT_OF_TOWN_ROTATION_ASSGN](../database-tables.md#out_of_town_rotation_assgn) | INSERT | See Sample SQL below |

### Sample SQL

```sql
-- Insert against OUT_OF_TOWN_ROTATION_ASSGN
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Insert statements against OUT_OF_TOWN_ROTATION_ASSGN in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsOutOFTownRotationAssgn.vb`

---
## SQL-039 clsRequestIssue.Criteria.InsertSQL

`clsRequestIssue.Criteria.InsertSQL` — Insert operation against `REQUEST_ISSUE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-039 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsRequestIssue` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | See enclosing `Before*`/`After*` hook in the source class |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [REQUEST_ISSUE](../database-tables.md#request_issue) | INSERT | See Sample SQL below |

### Sample SQL

```sql
-- Insert against REQUEST_ISSUE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Insert statements against REQUEST_ISSUE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsRequestIssue.vb`

---
## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [SQL catalog](index.md)
- [API reference](../api/index.md)

> **Note:** Statements marked with `*` were inferred from code structure, naming
> conventions, or contextual evidence where direct confirmation was not available
> in source artifacts. Statements marked with `**` could not be confirmed; treat
> as unknown until verified.

## Sources
- See per-SQL-ID Sources subsections above for exact .vb file/line citations.